package com.example.xiaomi.mapper;


import com.example.xiaomi.entity.wordfreq;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;
@Mapper
public interface WordfreqMapper {
    @Select("select * from word_frequency;")
    List<wordfreq> findAllfreq();
    @Select("select * from word_frequency  where frequency >20 order by frequency DESC; ")
    List<wordfreq> findfreq1();
    @Select("select * from word_frequency_today where frequency>1 \n" +
            "order by frequency DESC;")
    List<wordfreq> findfreq2();

}
